Data explorer view

This view displays the details of the CData Virtuality Server: the connected Data Sources, the Virtual Views and the Analytical Storage

Data Sources

Below the Data Sources tree node of the Data Explorer you can see all the source systems that are already connected to the CData Virtuality Server. In addition, CData Virtuality Server exposes the system schemas (SYS, SYSADMIN and pg_catalog) that hold system tables, views and stored procedures. See the reference manual for a detailed description of these.

• Right-click on the Data Sources node to add a new Data Source, refresh the list of Data Sources or list all statistical jobs.
• Right-click on a particular Data Source to disconnect it from the CData Virtuality Server, refresh its metadata, gather its statistical data or find all its statistical jobs.
• Double-click on the particular Data Source node or its "Tables / Views" sub-node to display the Data Source's tables / views list in a schema viewer.
• Double click on the Procedures sub-node of a particular Data Source to show its stored procedures in a schema viewer.

Virtual Schemas

A Virtual Schema is a special type of Data Source that is managed by the CData Virtuality Server itself and designed to store Virtual Views and Procedures. Virtual Views and Procedures are used to eliminate typing long queries, create business-friendly table and column names, rewrite data types, create calculated columns, encapsulate business logic or create helpful utility procedures and functions.

Virtual Views can be created as follows:

• Via the context menu of a table in a Data Source.
• Via the "Create view" command in the context menu of a virtual schemas' root node in the Data Explorer.
• In the SQL Editor by issuing a CREATE VIEW statement.

Analytical storage

The Analytical storage contains data originated from Data Sources in an optimized form to speed up requests coming from particular BI tools.

• Double-click on the Analytical storage node to show the list of tables.

Reference manual pages:

• Connecting Data Sources
  • Connection Configuration Interface
  • Translators
  • File Connector
  • Google Ads Connector
  • Google Analytics Connector
  • JDBC Connectors
    • BigQuery Connector
  • LDAP Connector
  • Loopback Connector
  • MongoDB Connector
  • OLAP Connector
  • SalesForce Connector
  • Web Services Connector
  • DHL Connector
  • Cassandra Connector
  • Connection- and Datasource-Examples